Define ODBC Table Import Settings

This screen is shown as the final stage of ODBC data import, and determines the fields that are imported into memory. You can restrict (filter) incoming data fields as required, although care must be taken that important fields are not left out - causing subsequent processes to fail.

This dialog also controls the 'mapping' of fields (how a field is translated during import). You can rename any field description, but be aware that Datamine applications expect a maximum of eight characters for field names, otherwise, automatic concatenation occurs.

Advanced controls are also accessible from this dialog, allowing you to commit SQL statements before and after import, and to specify general table details.

Activity steps

  1. Review the file summary information.

  2. Choose the Data Fields to import. Select as many fields as you need to import (all are precluded from import by default). By selecting an item in this list, the Target field and Target data fields update automatically (see below).

  3. For each data field selected for import, review the Target field. This field will update according to the selection made in the Data Fields list (see above).

  4. The ODBC driver attempts to distinguish between text and numeric values, however, the assignation of the eventual Target data type can be specified manually. Double must be set for all values that should be imported as numbers. Otherwise, String should be set for all alphanumeric fields.

  5. For each target data string field, set the maximum number of characters permitted for data entry (i.e. its Width). This option will not appear for numeric (double) fields.

  6. If you wish to specify further import options. Select Advanced. See Apply Advanced ODBC Import Settings.

  7. Click OK.

  8. If importing a file to a Studio project, the Import Files screen displays.

  9. Use the Import Files screen:

    1. Choose which Files to create and associate with your project.

    2. Confirm the Import Fields for this operation.

    3. If required, choose how to Rename Fields during import.

    4. Click OK.

      Files references are added to the project.